Node / ReticulumProjects / MeshChatX.git / files / meshchatx / src / backend / database / provider.py

Displaying Raw • Download

Tff7b72import T7ee787sqlite3

Tff7b72import T7ee787threading

Tff7b72class T56d364DatabaseProviderTb4b4b4:

Te6edf3_instance Tff7b72= Tff7b72None

Te6edf3_lock Tff7b72= Te6edf3threadingTff7b72.Td2a8ffLockTb4b4b4(Tb4b4b4)

Tff7b72def Tff7b72__init__Tb4b4b4(Tff7b72selfTb4b4b4, Te6edf3db_pathTff7b72=Tff7b72NoneTb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ffdb_path Tff7b72= Te6edf3db_path

Tff7b72selfTff7b72.Td2a8ff_local Tff7b72= Te6edf3threadingTff7b72.Td2a8fflocalTb4b4b4(Tb4b4b4)

Tf0883e@classmethod

Tff7b72def Td2a8ffget_instanceTb4b4b4(Tff7b72clsTb4b4b4, Te6edf3db_pathTff7b72=Tff7b72NoneTb4b4b4)Tb4b4b4:

Tff7b72with Tff7b72clsTff7b72.Td2a8ff_lockTb4b4b4:

Tff7b72if Tff7b72clsTff7b72.Td2a8ff_instance Tff7b72is Tff7b72NoneTb4b4b4:

Tff7b72if Te6edf3db_path Tff7b72is Tff7b72NoneTb4b4b4:

Te6edf3msg Tff7b72= Ta5d6ff"Ta5d6ffDatabase path must be provided for the first initializationTa5d6ff"

Tff7b72raise Tf85149ValueErrorTb4b4b4(Te6edf3msgTb4b4b4)

Tff7b72clsTff7b72.Td2a8ff_instance Tff7b72= Tff7b72clsTb4b4b4(Te6edf3db_pathTb4b4b4)

Tff7b72return Tff7b72clsTff7b72.Td2a8ff_instance

Tf0883e@property

Tff7b72def Td2a8ffconnectionTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72if Tff7b72not Tffa657hasattrTb4b4b4(Tff7b72selfTff7b72.Td2a8ff_localTb4b4b4, Ta5d6ff"Ta5d6ffconnectionTa5d6ff"Tb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ff_localTff7b72.Td2a8ffconnection Tff7b72= Te6edf3sqlite3Tff7b72.Td2a8ffconnectTb4b4b4(

Tff7b72selfTff7b72.Td2a8ffdb_pathTb4b4b4,

Te6edf3check_same_threadTff7b72=Tff7b72FalseTb4b4b4,

Tb4b4b4)

Tff7b72selfTff7b72.Td2a8ff_localTff7b72.Td2a8ffconnectionTff7b72.Td2a8ffrow_factory Tff7b72= Te6edf3sqlite3Tff7b72.Td2a8ffRow

T8b949e# Enable WAL mode for better concurrency

Tff7b72selfTff7b72.Td2a8ff_localTff7b72.Td2a8ffconnectionTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffPRAGMA journal_mode=WALTa5d6ff"Tb4b4b4)

Tff7b72return Tff7b72selfTff7b72.Td2a8ff_localTff7b72.Td2a8ffconnection

Tff7b72def Td2a8ffexecuteTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3queryTb4b4b4, Te6edf3paramsTff7b72=Tff7b72NoneTb4b4b4)Tb4b4b4:

Te6edf3cursor Tff7b72= Tff7b72selfTff7b72.Td2a8ffconnectionTff7b72.Td2a8ffcursorTb4b4b4(Tb4b4b4)

Tff7b72if Te6edf3paramsTb4b4b4:

Te6edf3cursorTff7b72.Td2a8ffexecuteTb4b4b4(Te6edf3queryTb4b4b4, Te6edf3paramsTb4b4b4)

Tff7b72elseTb4b4b4:

Te6edf3cursorTff7b72.Td2a8ffexecuteTb4b4b4(Te6edf3queryTb4b4b4)

Tff7b72selfTff7b72.Td2a8ffconnectionTff7b72.Td2a8ffcommitTb4b4b4(Tb4b4b4)

Tff7b72return Te6edf3cursor

Tff7b72def Td2a8fffetchoneTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3queryTb4b4b4, Te6edf3paramsTff7b72=Tff7b72NoneTb4b4b4)Tb4b4b4:

Te6edf3cursor Tff7b72= Tff7b72selfTff7b72.Td2a8ffexecuteTb4b4b4(Te6edf3queryTb4b4b4, Te6edf3paramsTb4b4b4)

Tff7b72return Te6edf3cursorTff7b72.Td2a8fffetchoneTb4b4b4(Tb4b4b4)

Tff7b72def Td2a8fffetchallTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3queryTb4b4b4, Te6edf3paramsTff7b72=Tff7b72NoneTb4b4b4)Tb4b4b4:

Te6edf3cursor Tff7b72= Tff7b72selfTff7b72.Td2a8ffexecuteTb4b4b4(Te6edf3queryTb4b4b4, Te6edf3paramsTb4b4b4)

Tff7b72return Te6edf3cursorTff7b72.Td2a8fffetchallTb4b4b4(Tb4b4b4)

Tff7b72def Td2a8ffcloseTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72if Tffa657hasattrTb4b4b4(Tff7b72selfTff7b72.Td2a8ff_localTb4b4b4, Ta5d6ff"Ta5d6ffconnectionTa5d6ff"Tb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ff_localTff7b72.Td2a8ffconnectionTff7b72.Td2a8ffcloseTb4b4b4(Tb4b4b4)

Tff7b72del Tff7b72selfTff7b72.Td2a8ff_localTff7b72.Td2a8ffconnection

Tff7b72def Td2a8ffvacuumTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffVACUUMTa5d6ff"Tb4b4b4)

Tff7b72def Td2a8ffintegrity_checkTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72return Tff7b72selfTff7b72.Td2a8fffetchallTb4b4b4(Ta5d6ff"Ta5d6ffPRAGMA integrity_checkTa5d6ff"Tb4b4b4)

Tff7b72def Td2a8ffquick_checkTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72return Tff7b72selfTff7b72.Td2a8fffetchallTb4b4b4(Ta5d6ff"Ta5d6ffPRAGMA quick_checkTa5d6ff"Tb4b4b4)

Tff7b72def Td2a8ffcheckpointTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72return Tff7b72selfTff7b72.Td2a8fffetchallTb4b4b4(Ta5d6ff"Ta5d6ffPRAGMA wal_checkpoint(TRUNCATE)Ta5d6ff"Tb4b4b4)